Toufong Vang
Toufong Vang
Reactions
-
Re: Reset sequence of number back to 1, based on date change.
Hi, @GRoush_CHC , here's one approach. Ensure that your auto-number column has no prefix nor suffix (so that it remains a number instead of a string/text), and rename it. Create a new "Sequence&…2 · -
Re: Automate message to a contact on a separate sheet
Hi, @MichelleN , you can use JOIN( COLLECT() ) to collect the email addresses for the department managers into a Managers cell/column: for example, bugs@acme.com;daffy@acme.com;elmer@acme.com. Then p…2 · -
Re: Dynamic "Week Of"
Hi, @kira11. Here's an approach that does not require a helper column. =WEEKNUMBER(IF(WEEKDAY(anyDate@row) = 1, anyDate@row - 6, anyDate@row - (WEEKDAY(anyDate@row) - 2))) EXPLANATION Since your week…1 · -
Re: How to count the number of events in a given month regardless of year.
@Hawk23 , switch the ranges around. Count "Term Type" instead of "Last Date of Employment". =COUNTIFS({Term Type}, "Resignation", {Last Date of Employment}, MONTH(@cell)…1 · -
Re: Adding "Months" to a Date (Column)
Hi, @Mark McGrath, my approach above does not work consistently. The following will work as intended. Give it a try. (Replace the temporary column names--COL1, COL2, ect.--with yours.) =DATE(IF((MONT…1 ·
